package com.lzw.DailyAudit.service.dateAggregation_02.DailyAudit.mapper;


import com.hooya.fa.eu.biz.DailyAudit.entity.dto.ProfitCheckDTO;
import com.hooya.fa.eu.biz.DailyAudit.entity.dto.StockListDTO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface DailyMetaExchangePlMapper {

    int batchReplaceExchangeRateData(@Param("params") List<Object[]> params);

    @Select("SELECT * FROM fa_eu.meta_exchange_pl")
    List<StockListDTO> getDataForStockList();

    @Select(" SELECT rateDate as ratedate, UsdPlnRate as usdplnrate, EurPlnRate as eurplnrate FROM fa_eu.meta_exchange_pl")
    List<ProfitCheckDTO> getDataForProFitCheck();

}